DirectLoanDisbursement

EntityType | Independent
Logical Entity Name | DirectLoanDisbursement
Default Table Name | FaDlDisb
Logical Only | NO
Owner | dbo
Definition |
Note |

DirectLoanDisbursement Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Id |  | INTEGER | NO |
StudentAwardLoanId |  | INTEGER | NO |
StudentAwardId |  | INTEGER | NO |
StudentAccountTransactionId |  | INTEGER | NO |
RefundId |  | INTEGER | YES |
DisbursementNumber |  | INTEGER | YES |
DisbursementType |  | CHAR(1) | YES |
transactiondate |  | DATETIME | YES |
DisbursementSequenceNumber |  | INTEGER | YES |
DisbursementGrossAmount |  | MONEY(19, 4) | YES |
DisbursementFeeAmount |  | MONEY(19, 4) | YES |
DisbursementNetAmount |  | MONEY(19, 4) | YES |
DisbursementNetAdjustment |  | MONEY(19, 4) | YES |
OriginalDisbursementDate |  | DATETIME | YES |
ExportBatchIdentifier |  | VARCHAR(30) | YES |
exportdate |  | DATETIME | YES |
acknowledgedate |  | DATETIME | YES |
DisbursementStatus |  | CHAR(1) | YES |
schoolcodestatus |  | CHAR(1) | YES |
LoanIdentifierStatus |  | CHAR(1) | YES |
DisbursementNumberStatus |  | CHAR(1) | YES |
DisbursementActivityCodes |  | CHAR(10) | YES |
transactiondatestatus |  | CHAR(1) | YES |
SequenceNumberStatus |  | CHAR(1) | YES |
LocDisbursementGrossAmount |  | MONEY(19, 4) | YES |
LocDisbursementFeeAmount |  | MONEY(19, 4) | YES |
LocDisbursementNetAmount |  | MONEY(19, 4) | YES |
LocNetAdjustment |  | MONEY(19, 4) | YES |
bookstatus |  | CHAR(1) | YES |
loctotalnetamount |  | MONEY(19, 4) | YES |
affirmationflag |  | CHAR(1) | YES |
LoanDetailBatchIdentifier |  | CHAR(23) | YES |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
BookDate |  | DATETIME | YES |
DisbursementRebateAmount |  | MONEY(19, 4) | YES |
IsFirstActualDisbursement |  | BIT | YES |
LocDisbursementRebateAmount |  | NUMERIC(18, 0) | YES |
ServicerRefundAmount |  | NUMERIC(18, 0) | YES |
ScheduledDisbursementId |  | INTEGER | YES |
PrevDisbursementSequenceNumber |  | INTEGER | YES |
CODCommentCodes |  | VARCHAR(100) | YES |

DirectLoanDisbursement Keys

Key Name | Key Type | Keys
FaDlDisb_FaStudentaidID_Disbnum_DisbSequencenum_N_N_IDX | Inversion Entry | StudentAwardId, DisbursementNumber, DisbursementSequenceNumber
FaDlDisb_faloanid_disbnum_disbsequencenum_N_N_IDX | Inversion Entry | StudentAwardLoanId, DisbursementNumber, DisbursementSequenceNumber
FaDLDisb_ExportBatchID_N_N_IDX | Inversion Entry | ExportBatchIdentifier
Nk_FaDLDisb_FaSchedId_FaDLDisbId | Inversion Entry | ScheduledDisbursementId, Id
FaDlDisb_FaDlDisbID_U_C_IDX | PrimaryKey | Id

DirectLoanDisbursement Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

DirectLoanDisbursement Check Constraints

Check Constraint Name | CheckConstraint

DirectLoanDisbursement Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.DirectLoanDisbursement | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaDlDisb | NO |  |  |

DirectLoanDisbursement Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

DirectLoanDisbursement Data Movement Rules

Name | Type | Rule Text/Value